Overview

Dataset statistics

Number of variables29
Number of observations19026
Missing cells244163
Missing cells (%)44.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.6 MiB
Average record size in memory475.8 B

Variable types

DateTime1
Categorical3
Numeric14
Unsupported11

Alerts

更換溫度時數 has constant value "180.0" Constant
原料分類 is highly correlated with 燒結溫度 and 1 other fieldsHigh correlation
燒結溫度 is highly correlated with 原料分類 and 1 other fieldsHigh correlation
速度 is highly correlated with 原料分類 and 1 other fieldsHigh correlation
重量(kg) is highly correlated with 單重(g) and 3 other fieldsHigh correlation
單重(g) is highly correlated with 重量(kg)High correlation
實際燒結時數 is highly correlated with 重量(kg) and 2 other fieldsHigh correlation
待料時數 is highly correlated with 工時(H) and 1 other fieldsHigh correlation
持溫時數 is highly correlated with 工時(H) and 1 other fieldsHigh correlation
工時(H) is highly correlated with 重量(kg) and 4 other fieldsHigh correlation
工時加總 is highly correlated with 重量(kg) and 4 other fieldsHigh correlation
重量(kg) is highly correlated with 實際燒結時數 and 2 other fieldsHigh correlation
實際燒結時數 is highly correlated with 重量(kg) and 2 other fieldsHigh correlation
待料時數 is highly correlated with 工時(H) and 1 other fieldsHigh correlation
持溫時數 is highly correlated with 工時(H) and 1 other fieldsHigh correlation
工時(H) is highly correlated with 重量(kg) and 4 other fieldsHigh correlation
工時加總 is highly correlated with 重量(kg) and 4 other fieldsHigh correlation
原料分類 is highly correlated with 燒結溫度 and 1 other fieldsHigh correlation
燒結溫度 is highly correlated with 原料分類 and 1 other fieldsHigh correlation
速度 is highly correlated with 原料分類 and 1 other fieldsHigh correlation
重量(kg) is highly correlated with 實際燒結時數 and 2 other fieldsHigh correlation
實際燒結時數 is highly correlated with 重量(kg) and 2 other fieldsHigh correlation
待料時數 is highly correlated with 工時(H) and 1 other fieldsHigh correlation
持溫時數 is highly correlated with 工時(H) and 1 other fieldsHigh correlation
工時(H) is highly correlated with 重量(kg) and 4 other fieldsHigh correlation
工時加總 is highly correlated with 重量(kg) and 4 other fieldsHigh correlation
爐號 is highly correlated with 原料分類 and 2 other fieldsHigh correlation
原料分類 is highly correlated with 爐號 and 2 other fieldsHigh correlation
速度 is highly correlated with 爐號 and 1 other fieldsHigh correlation
重量(kg) is highly correlated with 工時(H) and 1 other fieldsHigh correlation
實際燒結時數 is highly correlated with 工時(H) and 1 other fieldsHigh correlation
待料時數 is highly correlated with 工時(H) and 1 other fieldsHigh correlation
持溫時數 is highly correlated with 表單編號 and 2 other fieldsHigh correlation
表單編號 is highly correlated with 爐號 and 2 other fieldsHigh correlation
工時(H) is highly correlated with 重量(kg) and 4 other fieldsHigh correlation
工時加總 is highly correlated with 重量(kg) and 4 other fieldsHigh correlation
原料分類 has 4658 (24.5%) missing values Missing
原料 has 5601 (29.4%) missing values Missing
品編 has 4330 (22.8%) missing values Missing
批號 has 5066 (26.6%) missing values Missing
燒結溫度 has 4331 (22.8%) missing values Missing
速度 has 4348 (22.9%) missing values Missing
急冷 has 19026 (100.0%) missing values Missing
速率 has 19026 (100.0%) missing values Missing
快速脫臘 has 19026 (100.0%) missing values Missing
重量(kg) has 5157 (27.1%) missing values Missing
實際燒結時數 has 4308 (22.6%) missing values Missing
待料時數 has 14841 (78.0%) missing values Missing
持溫時數 has 18964 (99.7%) missing values Missing
更換溫度時數 has 19025 (> 99.9%) missing values Missing
爐體維修時間 has 19026 (100.0%) missing values Missing
表單編號 has 15718 (82.6%) missing values Missing
確認者 has 696 (3.7%) missing values Missing
填表人 has 19026 (100.0%) missing values Missing
收料者 has 655 (3.4%) missing values Missing
盒數 has 17709 (93.1%) missing values Missing
箱數 has 5356 (28.2%) missing values Missing
燒結狀態 has 18247 (95.9%) missing values Missing
燒結溫度 is highly skewed (γ1 = 48.61856227) Skewed
原料 is an unsupported type, check if it needs cleaning or further analysis Unsupported
品編 is an unsupported type, check if it needs cleaning or further analysis Unsupported
批號 is an unsupported type, check if it needs cleaning or further analysis Unsupported
急冷 is an unsupported type, check if it needs cleaning or further analysis Unsupported
速率 is an unsupported type, check if it needs cleaning or further analysis Unsupported
快速脫臘 is an unsupported type, check if it needs cleaning or further analysis Unsupported
爐體維修時間 is an unsupported type, check if it needs cleaning or further analysis Unsupported
填表人 is an unsupported type, check if it needs cleaning or further analysis Unsupported
盒數 is an unsupported type, check if it needs cleaning or further analysis Unsupported
箱數 is an unsupported type, check if it needs cleaning or further analysis Unsupported
燒結狀態 is an unsupported type, check if it needs cleaning or further analysis Unsupported
數量 has 5130 (27.0%) zeros Zeros

Reproduction

Analysis started2022-04-24 15:48:46.323983
Analysis finished2022-04-24 15:49:21.596917
Duration35.27 seconds
Software versionpandas-profiling v3.1.0
Download configurationconfig.json

Variables

日期
Date

Distinct357
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size148.8 KiB
Minimum2022-01-01 00:00:00
Maximum2022-12-31 00:00:00
2022-04-24T23:49:21.706624image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:21.855005image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

班別
Categorical

Distinct5
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.1 MiB
C
9559 
A
9463 
B
 
2
CD
 
1
C
 
1

Length

Max length2
Median length1
Mean length1.000105119
Min length1

Characters and Unicode

Total characters0
Distinct characters0
Distinct categories0 ?
Distinct scripts0 ?
Distinct blocks0 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st rowC
2nd rowC
3rd rowA
4th rowA
5th rowA

Common Values

ValueCountFrequency (%)
C9559
50.2%
A9463
49.7%
B2
 
< 0.1%
CD1
 
< 0.1%
C1
 
< 0.1%

Length

2022-04-24T23:49:22.004884image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram of lengths of the category

Pie chart

2022-04-24T23:49:22.083676image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
ValueCountFrequency (%)
c9560
50.2%
a9463
49.7%
b2
 
< 0.1%
cd1
 
< 0.1%

Most occurring characters

ValueCountFrequency (%)
No values found.

Most occurring categories

ValueCountFrequency (%)
No values found.

Most frequent character per category

Most occurring scripts

ValueCountFrequency (%)
No values found.

Most frequent character per script

Most occurring blocks

ValueCountFrequency (%)
No values found.

Most frequent character per block

爐號
Real number (ℝ≥0)

HIGH CORRELATION

Distinct9
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.184011353
Minimum1
Maximum9
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:22.167030image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median4
Q36
95-th percentile8
Maximum9
Range8
Interquartile range (IQR)4

Descriptive statistics

Standard deviation2.46376928
Coefficient of variation (CV)0.5888533927
Kurtosis-1.221500607
Mean4.184011353
Median Absolute Deviation (MAD)2
Skewness0.2527713456
Sum79605
Variance6.070159067
MonotonicityNot monotonic
2022-04-24T23:49:22.266576image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
13546
18.6%
22780
14.6%
42233
11.7%
32233
11.7%
82051
10.8%
72022
10.6%
51956
10.3%
61773
9.3%
9432
 
2.3%
ValueCountFrequency (%)
13546
18.6%
22780
14.6%
32233
11.7%
42233
11.7%
51956
10.3%
61773
9.3%
72022
10.6%
82051
10.8%
9432
 
2.3%
ValueCountFrequency (%)
9432
 
2.3%
82051
10.8%
72022
10.6%
61773
9.3%
51956
10.3%
42233
11.7%
32233
11.7%
22780
14.6%
13546
18.6%

原料分類
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct4
Distinct (%)< 0.1%
Missing4658
Missing (%)24.5%
Memory size1024.0 KiB
1.0
12040 
3.0
2296 
2.0
 
28
24.0
 
4

Length

Max length4
Median length3
Mean length3.000278396
Min length3

Characters and Unicode

Total characters0
Distinct characters0
Distinct categories0 ?
Distinct scripts0 ?
Distinct blocks0 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1.0
2nd row1.0
3rd row1.0
4th row1.0
5th row1.0

Common Values

ValueCountFrequency (%)
1.012040
63.3%
3.02296
 
12.1%
2.028
 
0.1%
24.04
 
< 0.1%
(Missing)4658
 
24.5%

Length

2022-04-24T23:49:22.383572image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram of lengths of the category

Pie chart

2022-04-24T23:49:22.457603image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
ValueCountFrequency (%)
1.012040
83.8%
3.02296
 
16.0%
2.028
 
0.2%
24.04
 
< 0.1%

Most occurring characters

ValueCountFrequency (%)
No values found.

Most occurring categories

ValueCountFrequency (%)
No values found.

Most frequent character per category

Most occurring scripts

ValueCountFrequency (%)
No values found.

Most frequent character per script

Most occurring blocks

ValueCountFrequency (%)
No values found.

Most frequent character per block

原料
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing5601
Missing (%)29.4%
Memory size962.9 KiB

品編
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing4330
Missing (%)22.8%
Memory size678.6 KiB

批號
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing5066
Missing (%)26.6%
Memory size1005.6 KiB

燒結溫度
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED

Distinct35
Distinct (%)0.2%
Missing4331
Missing (%)22.8%
Infinite0
Infinite (%)0.0%
Mean1123.898632
Minimum50
Maximum11220
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:22.553732image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum50
5-th percentile1120
Q11120
median1120
Q31120
95-th percentile1150
Maximum11220
Range11170
Interquartile range (IQR)0

Descriptive statistics

Standard deviation192.395128
Coefficient of variation (CV)0.1711854811
Kurtosis2559.557907
Mean1123.898632
Median Absolute Deviation (MAD)0
Skewness48.61856227
Sum16515690.4
Variance37015.88528
MonotonicityNot monotonic
2022-04-24T23:49:22.686521image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
112011802
62.0%
11501789
 
9.4%
1135233
 
1.2%
1164210
 
1.1%
1130129
 
0.7%
111098
 
0.5%
113496
 
0.5%
114069
 
0.4%
105061
 
0.3%
100035
 
0.2%
Other values (25)173
 
0.9%
(Missing)4331
 
22.8%
ValueCountFrequency (%)
508
 
< 0.1%
609
 
< 0.1%
1102
 
< 0.1%
1121
 
< 0.1%
113.41
 
< 0.1%
6001
 
< 0.1%
70012
0.1%
7607
 
< 0.1%
80027
0.1%
8403
 
< 0.1%
ValueCountFrequency (%)
112204
 
< 0.1%
111201
 
< 0.1%
1164210
 
1.1%
11604
 
< 0.1%
11553
 
< 0.1%
11501789
9.4%
11442
 
< 0.1%
114069
 
0.4%
1135233
 
1.2%
113496
 
0.5%

速度
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct21
Distinct (%)0.1%
Missing4348
Missing (%)22.9%
Infinite0
Infinite (%)0.0%
Mean59.26890585
Minimum25
Maximum90
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:22.807744image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum25
5-th percentile50
Q160
median60
Q360
95-th percentile70
Maximum90
Range65
Interquartile range (IQR)0

Descriptive statistics

Standard deviation6.03598952
Coefficient of variation (CV)0.1018407449
Kurtosis5.808293575
Mean59.26890585
Median Absolute Deviation (MAD)0
Skewness0.7073004766
Sum869949
Variance36.43316949
MonotonicityNot monotonic
2022-04-24T23:49:22.917454image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
6011265
59.2%
501963
 
10.3%
80578
 
3.0%
55348
 
1.8%
70263
 
1.4%
5395
 
0.5%
4045
 
0.2%
3326
 
0.1%
4622
 
0.1%
6517
 
0.1%
Other values (11)56
 
0.3%
(Missing)4348
 
22.9%
ValueCountFrequency (%)
258
 
< 0.1%
3013
 
0.1%
3326
 
0.1%
348
 
< 0.1%
4045
 
0.2%
435
 
< 0.1%
456
 
< 0.1%
4622
 
0.1%
489
 
< 0.1%
501963
10.3%
ValueCountFrequency (%)
903
 
< 0.1%
80578
 
3.0%
70263
 
1.4%
6517
 
0.1%
641
 
< 0.1%
631
 
< 0.1%
621
 
< 0.1%
611
 
< 0.1%
6011265
59.2%
55348
 
1.8%

急冷
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing19026
Missing (%)100.0%
Memory size148.8 KiB

速率
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing19026
Missing (%)100.0%
Memory size148.8 KiB

快速脫臘
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing19026
Missing (%)100.0%
Memory size148.8 KiB

重量(kg)
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct2165
Distinct (%)15.6%
Missing5157
Missing (%)27.1%
Infinite0
Infinite (%)0.0%
Mean129.1806958
Minimum0
Maximum1629
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:23.052914image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile13.5
Q140
median82
Q3177.7
95-th percentile388
Maximum1629
Range1629
Interquartile range (IQR)137.7

Descriptive statistics

Standard deviation128.7056065
Coefficient of variation (CV)0.996322289
Kurtosis5.176400403
Mean129.1806958
Median Absolute Deviation (MAD)54
Skewness1.958436042
Sum1791607.07
Variance16565.13315
MonotonicityNot monotonic
2022-04-24T23:49:23.202513image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20530
 
2.8%
40468
 
2.5%
60399
 
2.1%
80259
 
1.4%
100214
 
1.1%
120165
 
0.9%
140157
 
0.8%
10122
 
0.6%
51.8119
 
0.6%
160118
 
0.6%
Other values (2155)11318
59.5%
(Missing)5157
27.1%
ValueCountFrequency (%)
01
 
< 0.1%
0.51
 
< 0.1%
0.72
 
< 0.1%
0.82
 
< 0.1%
14
< 0.1%
1.22
 
< 0.1%
1.31
 
< 0.1%
1.55
< 0.1%
1.62
 
< 0.1%
1.71
 
< 0.1%
ValueCountFrequency (%)
16291
 
< 0.1%
898.91
 
< 0.1%
862.41
 
< 0.1%
794.51
 
< 0.1%
7801
 
< 0.1%
739.210
 
0.1%
709.51
 
< 0.1%
707.71
 
< 0.1%
707.410
 
0.1%
691.626
0.1%

單重(g)
Real number (ℝ≥0)

HIGH CORRELATION

Distinct1391
Distinct (%)7.3%
Missing23
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean139.6020938
Minimum0.09
Maximum4517
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:23.362087image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0.09
5-th percentile1
Q11
median22.05
Q3271.5
95-th percentile540
Maximum4517
Range4516.91
Interquartile range (IQR)270.5

Descriptive statistics

Standard deviation199.0073181
Coefficient of variation (CV)1.425532474
Kurtosis17.94699145
Mean139.6020938
Median Absolute Deviation (MAD)21.05
Skewness2.073775351
Sum2652858.588
Variance39603.91266
MonotonicityNot monotonic
2022-04-24T23:49:23.506740image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
14676
24.6%
5401003
 
5.3%
440761
 
4.0%
393742
 
3.9%
313.7346
 
1.8%
4.48332
 
1.7%
422279
 
1.5%
4.6256
 
1.3%
89197
 
1.0%
639151
 
0.8%
Other values (1381)10260
53.9%
ValueCountFrequency (%)
0.093
 
< 0.1%
0.123
 
< 0.1%
0.154
 
< 0.1%
0.256
 
< 0.1%
0.2611
0.1%
0.275
 
< 0.1%
0.2817
0.1%
0.32
 
< 0.1%
0.311
 
< 0.1%
0.334
 
< 0.1%
ValueCountFrequency (%)
45171
 
< 0.1%
36891
 
< 0.1%
11631
 
< 0.1%
10102
 
< 0.1%
10022
 
< 0.1%
10002
 
< 0.1%
9812
 
< 0.1%
972.63
< 0.1%
8752
 
< 0.1%
874.55
< 0.1%

數量
Real number (ℝ≥0)

ZEROS

Distinct7136
Distinct (%)37.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3336.355441
Minimum0
Maximum553571.4286
Zeros5130
Zeros (%)27.0%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:23.650967image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median611.944056
Q32733.269263
95-th percentile16807.3286
Maximum553571.4286
Range553571.4286
Interquartile range (IQR)2733.269263

Descriptive statistics

Standard deviation8376.277344
Coefficient of variation (CV)2.510607006
Kurtosis1002.525845
Mean3336.355441
Median Absolute Deviation (MAD)611.944056
Skewness18.27410708
Sum63477498.63
Variance70162022.15
MonotonicityNot monotonic
2022-04-24T23:49:23.899994image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
05130
 
27.0%
800124
 
0.7%
95.92592593116
 
0.6%
12089
 
0.5%
71.8518518580
 
0.4%
160070
 
0.4%
60067
 
0.4%
9067
 
0.4%
224.881516656
 
0.3%
56055
 
0.3%
Other values (7126)13172
69.2%
ValueCountFrequency (%)
05130
27.0%
21
 
< 0.1%
31
 
< 0.1%
41
 
< 0.1%
61
 
< 0.1%
7.9629629632
 
< 0.1%
104
 
< 0.1%
10.925925931
 
< 0.1%
122
 
< 0.1%
12.56983241
 
< 0.1%
ValueCountFrequency (%)
553571.42861
< 0.1%
132558.13951
< 0.1%
122674.41861
< 0.1%
121428.57141
< 0.1%
1160001
< 0.1%
112903.22581
< 0.1%
1125001
< 0.1%
101382.48851
< 0.1%
93023.255811
< 0.1%
92105.263161
< 0.1%

實際燒結時數
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct94
Distinct (%)0.6%
Missing4308
Missing (%)22.6%
Infinite0
Infinite (%)0.0%
Mean202.9660959
Minimum5
Maximum480
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:24.047677image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile30
Q190
median180
Q3240
95-th percentile480
Maximum480
Range475
Interquartile range (IQR)150

Descriptive statistics

Standard deviation139.2607303
Coefficient of variation (CV)0.6861280434
Kurtosis-0.4115739012
Mean202.9660959
Median Absolute Deviation (MAD)85
Skewness0.7417691164
Sum2987255
Variance19393.551
MonotonicityNot monotonic
2022-04-24T23:49:24.199276image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2402882
15.1%
4801828
 
9.6%
60967
 
5.1%
120834
 
4.4%
90678
 
3.6%
180665
 
3.5%
150517
 
2.7%
30500
 
2.6%
210319
 
1.7%
40291
 
1.5%
Other values (84)5237
27.5%
(Missing)4308
22.6%
ValueCountFrequency (%)
593
 
0.5%
10192
 
1.0%
1549
 
0.3%
20152
 
0.8%
2546
 
0.2%
30500
2.6%
3541
 
0.2%
40291
1.5%
4581
 
0.4%
50234
1.2%
ValueCountFrequency (%)
4801828
9.6%
4701
 
< 0.1%
4652
 
< 0.1%
46012
 
0.1%
4552
 
< 0.1%
45045
 
0.2%
4451
 
< 0.1%
44025
 
0.1%
4356
 
< 0.1%
43018
 
0.1%

待料時數
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct79
Distinct (%)1.9%
Missing14841
Missing (%)78.0%
Infinite0
Infinite (%)0.0%
Mean298.9713262
Minimum10
Maximum720
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:24.341294image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile60
Q1240
median240
Q3480
95-th percentile480
Maximum720
Range710
Interquartile range (IQR)240

Descriptive statistics

Standard deviation146.959868
Coefficient of variation (CV)0.4915517147
Kurtosis-1.207339039
Mean298.9713262
Median Absolute Deviation (MAD)120
Skewness0.05814542112
Sum1251195
Variance21597.20281
MonotonicityNot monotonic
2022-04-24T23:49:24.484949image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2401585
 
8.3%
4801433
 
7.5%
60133
 
0.7%
180116
 
0.6%
120115
 
0.6%
9085
 
0.4%
3073
 
0.4%
15072
 
0.4%
21055
 
0.3%
8029
 
0.2%
Other values (69)489
 
2.6%
(Missing)14841
78.0%
ValueCountFrequency (%)
106
 
< 0.1%
152
 
< 0.1%
2021
 
0.1%
255
 
< 0.1%
3073
0.4%
351
 
< 0.1%
4018
 
0.1%
454
 
< 0.1%
5021
 
0.1%
553
 
< 0.1%
ValueCountFrequency (%)
7204
 
< 0.1%
5701
 
< 0.1%
4801433
7.5%
4508
 
< 0.1%
4406
 
< 0.1%
4303
 
< 0.1%
42023
 
0.1%
4151
 
< 0.1%
4103
 
< 0.1%
4003
 
< 0.1%

持溫時數
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct20
Distinct (%)32.3%
Missing18964
Missing (%)99.7%
Infinite0
Infinite (%)0.0%
Mean259.516129
Minimum20
Maximum480
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:24.618555image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum20
5-th percentile41
Q1146.25
median240
Q3420
95-th percentile480
Maximum480
Range460
Interquartile range (IQR)273.75

Descriptive statistics

Standard deviation152.4787265
Coefficient of variation (CV)0.5875500958
Kurtosis-1.179696458
Mean259.516129
Median Absolute Deviation (MAD)120
Skewness0.2867041535
Sum16090
Variance23249.76203
MonotonicityNot monotonic
2022-04-24T23:49:24.734828image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
48015
 
0.1%
24013
 
0.1%
1205
 
< 0.1%
605
 
< 0.1%
1803
 
< 0.1%
2002
 
< 0.1%
1502
 
< 0.1%
2102
 
< 0.1%
3602
 
< 0.1%
302
 
< 0.1%
Other values (10)11
 
0.1%
(Missing)18964
99.7%
ValueCountFrequency (%)
201
 
< 0.1%
302
 
< 0.1%
401
 
< 0.1%
605
< 0.1%
1205
< 0.1%
1301
 
< 0.1%
1451
 
< 0.1%
1502
 
< 0.1%
1701
 
< 0.1%
1803
< 0.1%
ValueCountFrequency (%)
48015
0.1%
4202
 
< 0.1%
3602
 
< 0.1%
3301
 
< 0.1%
3001
 
< 0.1%
2701
 
< 0.1%
24013
0.1%
2102
 
< 0.1%
2002
 
< 0.1%
1851
 
< 0.1%

更換溫度時數
Categorical

CONSTANT
MISSING
REJECTED

Distinct1
Distinct (%)100.0%
Missing19025
Missing (%)> 99.9%
Memory size743.3 KiB
180.0

Length

Max length5
Median length5
Mean length5
Min length5

Characters and Unicode

Total characters0
Distinct characters0
Distinct categories0 ?
Distinct scripts0 ?
Distinct blocks0 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row180.0

Common Values

ValueCountFrequency (%)
180.01
 
< 0.1%
(Missing)19025
> 99.9%

Length

2022-04-24T23:49:24.850037image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram of lengths of the category

Pie chart

2022-04-24T23:49:24.919852image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
ValueCountFrequency (%)
180.01
100.0%

Most occurring characters

ValueCountFrequency (%)
No values found.

Most occurring categories

ValueCountFrequency (%)
No values found.

Most frequent character per category

Most occurring scripts

ValueCountFrequency (%)
No values found.

Most frequent character per script

Most occurring blocks

ValueCountFrequency (%)
No values found.

Most frequent character per block

爐體維修時間
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing19026
Missing (%)100.0%
Memory size148.8 KiB

表單編號
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct562
Distinct (%)17.0%
Missing15718
Missing (%)82.6%
Infinite0
Infinite (%)0.0%
Mean1319.492443
Minimum1
Maximum4415
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:25.007973image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile29.35
Q1364
median629
Q32525
95-th percentile4282
Maximum4415
Range4414
Interquartile range (IQR)2161

Descriptive statistics

Standard deviation1253.793839
Coefficient of variation (CV)0.9502091851
Kurtosis-0.3834289233
Mean1319.492443
Median Absolute Deviation (MAD)413
Skewness0.8984607071
Sum4364881
Variance1571998.99
MonotonicityNot monotonic
2022-04-24T23:49:25.156089image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2858134
 
0.7%
37010
 
0.1%
58510
 
0.1%
61610
 
0.1%
104510
 
0.1%
32710
 
0.1%
95410
 
0.1%
60210
 
0.1%
233610
 
0.1%
36110
 
0.1%
Other values (552)3084
 
16.2%
(Missing)15718
82.6%
ValueCountFrequency (%)
16
< 0.1%
27
< 0.1%
37
< 0.1%
48
< 0.1%
59
< 0.1%
65
< 0.1%
77
< 0.1%
88
< 0.1%
96
< 0.1%
104
< 0.1%
ValueCountFrequency (%)
44157
< 0.1%
44144
 
< 0.1%
44134
 
< 0.1%
44124
 
< 0.1%
44114
 
< 0.1%
44107
< 0.1%
44092
 
< 0.1%
440810
0.1%
440710
0.1%
44062
 
< 0.1%

確認者
Real number (ℝ≥0)

MISSING

Distinct44
Distinct (%)0.2%
Missing696
Missing (%)3.7%
Infinite0
Infinite (%)0.0%
Mean250.2063501
Minimum0
Maximum3698
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:25.301523image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile49
Q1248
median248
Q3325
95-th percentile398
Maximum3698
Range3698
Interquartile range (IQR)77

Descriptive statistics

Standard deviation149.3154731
Coefficient of variation (CV)0.5967693188
Kurtosis194.0862827
Mean250.2063501
Median Absolute Deviation (MAD)38
Skewness9.255249186
Sum4586282.398
Variance22295.11052
MonotonicityNot monotonic
2022-04-24T23:49:25.439760image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=44)
ValueCountFrequency (%)
2485806
30.5%
493596
18.9%
2863484
18.3%
3981809
 
9.5%
3481502
 
7.9%
3251455
 
7.6%
300384
 
2.0%
283217
 
1.1%
488
 
< 0.1%
3465
 
< 0.1%
Other values (34)64
 
0.3%
(Missing)696
 
3.7%
ValueCountFrequency (%)
01
 
< 0.1%
0.3981
 
< 0.1%
92
 
< 0.1%
194
 
< 0.1%
281
 
< 0.1%
302
 
< 0.1%
382
 
< 0.1%
488
 
< 0.1%
493596
18.9%
942
 
< 0.1%
ValueCountFrequency (%)
36982
< 0.1%
33984
< 0.1%
33482
< 0.1%
33251
 
< 0.1%
32864
< 0.1%
32484
< 0.1%
30491
 
< 0.1%
28361
 
< 0.1%
24831
 
< 0.1%
24481
 
< 0.1%

填表人
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing19026
Missing (%)100.0%
Memory size148.8 KiB

收料者
Real number (ℝ≥0)

MISSING

Distinct49
Distinct (%)0.3%
Missing655
Missing (%)3.4%
Infinite0
Infinite (%)0.0%
Mean327.8369501
Minimum3.61
Maximum4243
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:25.591876image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum3.61
5-th percentile94
Q1318
median346
Q3368
95-th percentile369
Maximum4243
Range4239.39
Interquartile range (IQR)50

Descriptive statistics

Standard deviation180.7938518
Coefficient of variation (CV)0.5514749077
Kurtosis254.3737228
Mean327.8369501
Median Absolute Deviation (MAD)22
Skewness14.55732574
Sum6022692.61
Variance32686.41685
MonotonicityNot monotonic
2022-04-24T23:49:25.736528image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
3612639
13.9%
3692587
13.6%
3682553
13.4%
3242549
13.4%
3182504
13.2%
3462231
11.7%
2172146
11.3%
94970
 
5.1%
34825
 
0.1%
31917
 
0.1%
Other values (39)150
 
0.8%
(Missing)655
 
3.4%
ValueCountFrequency (%)
3.611
 
< 0.1%
91
 
< 0.1%
271
 
< 0.1%
311
 
< 0.1%
381
 
< 0.1%
496
 
< 0.1%
94970
5.1%
1024
 
< 0.1%
1491
 
< 0.1%
2172146
11.3%
ValueCountFrequency (%)
42431
 
< 0.1%
39691
 
< 0.1%
36994
< 0.1%
36682
 
< 0.1%
36615
< 0.1%
36241
 
< 0.1%
36132
 
< 0.1%
34831
 
< 0.1%
34693
< 0.1%
33683
< 0.1%

盒數
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing17709
Missing (%)93.1%
Memory size600.0 KiB

箱數
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing5356
Missing (%)28.2%
Memory size648.1 KiB

燒結狀態
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing18247
Missing (%)95.9%
Memory size597.8 KiB

工時(H)
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct97
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.72711027
Minimum0
Maximum12
Zeros61
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:25.880107image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.5
Q11.666666667
median4
Q34.5
95-th percentile8
Maximum12
Range12
Interquartile range (IQR)2.833333333

Descriptive statistics

Standard deviation2.447716131
Coefficient of variation (CV)0.6567329522
Kurtosis-0.7629773019
Mean3.72711027
Median Absolute Deviation (MAD)2
Skewness0.5674176199
Sum70912
Variance5.991314257
MonotonicityNot monotonic
2022-04-24T23:49:26.136463image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
44480
23.5%
83277
17.2%
11105
 
5.8%
2954
 
5.0%
3785
 
4.1%
1.5763
 
4.0%
2.5591
 
3.1%
0.5574
 
3.0%
3.5376
 
2.0%
0.666666667310
 
1.6%
Other values (87)5811
30.5%
ValueCountFrequency (%)
061
 
0.3%
0.08333333393
 
0.5%
0.166666667198
 
1.0%
0.2551
 
0.3%
0.333333333174
 
0.9%
0.41666666751
 
0.3%
0.5574
3.0%
0.58333333342
 
0.2%
0.666666667310
1.6%
0.7585
 
0.4%
ValueCountFrequency (%)
124
 
< 0.1%
9.51
 
< 0.1%
83277
17.2%
7.8333333331
 
< 0.1%
7.752
 
< 0.1%
7.66666666712
 
0.1%
7.5833333332
 
< 0.1%
7.552
 
0.3%
7.4166666671
 
< 0.1%
7.33333333331
 
0.2%

工時加總
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct97
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean223.6266162
Minimum0
Maximum720
Zeros61
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size148.8 KiB
2022-04-24T23:49:26.276091image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile30
Q1100
median240
Q3270
95-th percentile480
Maximum720
Range720
Interquartile range (IQR)170

Descriptive statistics

Standard deviation146.8629679
Coefficient of variation (CV)0.6567329522
Kurtosis-0.7629773019
Mean223.6266162
Median Absolute Deviation (MAD)120
Skewness0.5674176199
Sum4254720
Variance21568.73133
MonotonicityNot monotonic
2022-04-24T23:49:26.416678image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2404480
23.5%
4803277
17.2%
601105
 
5.8%
120954
 
5.0%
180785
 
4.1%
90763
 
4.0%
150591
 
3.1%
30574
 
3.0%
210376
 
2.0%
40310
 
1.6%
Other values (87)5811
30.5%
ValueCountFrequency (%)
061
 
0.3%
593
 
0.5%
10198
 
1.0%
1551
 
0.3%
20174
 
0.9%
2551
 
0.3%
30574
3.0%
3542
 
0.2%
40310
1.6%
4585
 
0.4%
ValueCountFrequency (%)
7204
 
< 0.1%
5701
 
< 0.1%
4803277
17.2%
4701
 
< 0.1%
4652
 
< 0.1%
46012
 
0.1%
4552
 
< 0.1%
45052
 
0.3%
4451
 
< 0.1%
44031
 
0.2%

Interactions

2022-04-24T23:49:17.195544image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:52.111480image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:54.159042image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:56.015895image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:57.999801image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:59.974157image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:01.944258image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:03.873954image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:05.835486image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:07.698091image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:09.364881image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:11.184330image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:13.275435image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:15.151225image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:17.348142image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:52.260607image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:54.300667image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:56.159728image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:58.153391image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:00.112724image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:02.088835image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:04.017576image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:05.993961image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:07.816773image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:09.504807image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:11.330939image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:13.415901image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:15.292847image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:17.486768image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:52.397205image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:54.433767image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:56.291377image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:58.292164image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:00.242413image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:02.220520image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:04.153693image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:06.110916image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:07.921017image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:09.632973image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:11.477512image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:13.547750image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:15.433471image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:17.621924image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:52.537829image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:54.568410image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:56.436952image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:58.437542image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:00.372028image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:02.358706image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:04.295786image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:06.229129image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:08.025736image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:09.766123image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:11.619172image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:13.683425image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:15.578084image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:17.776589image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:52.783261image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:54.716013image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:56.584656image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:58.597116image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:00.511655image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:02.509093image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:04.439463image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:06.355750image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:08.145454image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:09.898800image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:11.771726image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:13.828000image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:15.730185image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:17.914184image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:52.917862image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:54.849167image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:56.827143image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:58.733749image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:00.639347image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:02.642737image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:04.567095image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:06.486812image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:08.261144image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:10.026428image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:11.903409image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:13.953685image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:15.868368image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:18.054435image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:53.055516image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:54.981397image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:56.961353image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:58.875877image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:00.878778image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:02.776799image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:04.711670image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:06.627400image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:08.368855image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:10.159073image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:12.051016image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:14.084987image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:16.004005image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:18.189281image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:53.190704image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:55.115077image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:57.096573image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:59.017011image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:01.017540image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:02.915430image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:04.841325image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:06.743091image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:08.475534image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:10.284737image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:12.189178image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:14.213752image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:16.141646image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:18.329614image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:53.338580image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:55.225476image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:57.207264image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:59.139683image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:01.156633image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:03.053089image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:05.053755image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:06.883465image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:08.581312image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:10.422369image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:12.332205image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:14.353344image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:16.283334image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:18.440318image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:53.451467image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:55.327208image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:57.307140image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:59.261536image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:01.269622image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:03.165795image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:05.159474image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:06.984196image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:08.803246image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:10.523099image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:12.447897image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:14.467528image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:16.395072image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:18.578989image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:53.583567image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:55.459362image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:57.441673image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:59.389232image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:01.397686image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:03.303432image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:05.288067image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:07.128810image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:08.910006image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:10.644483image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:12.699439image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:14.607206image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:16.523897image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:18.728548image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:53.728688image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:55.599010image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:57.583911image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:59.539198image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:01.532389image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:03.456019image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:05.428994image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:07.272265image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:09.029637image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:10.774649image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:12.850509image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:14.747308image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:16.779653image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:18.867177image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:53.862834image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:55.731655image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:57.715165image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:59.675420image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:01.658024image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:03.590659image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:05.559722image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:07.414848image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:09.137783image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:10.912357image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:12.985148image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:14.873007image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:16.912551image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:19.008835image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:54.008408image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:55.880260image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:57.864738image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:48:59.829480image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:01.799645image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:03.732281image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:05.699347image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:07.550485image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:09.254509image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:11.039996image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:13.124776image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:15.004618image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-04-24T23:49:17.057912image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Correlations

2022-04-24T23:49:26.584806image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2022-04-24T23:49:26.889578image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2022-04-24T23:49:27.183143image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2022-04-24T23:49:27.469341image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

2022-04-24T23:49:19.340456image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
A simple visualization of nullity by column.
2022-04-24T23:49:20.341594image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2022-04-24T23:49:20.827350image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
2022-04-24T23:49:21.381721image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

Sample

First rows

日期班別爐號原料分類原料品編批號燒結溫度速度急冷速率快速脫臘重量(kg)單重(g)數量實際燒結時數待料時數持溫時數更換溫度時數爐體維修時間表單編號確認者填表人收料者盒數箱數燒結狀態工時(H)工時加總
02022-01-01C1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1.000.000000NaN90.0NaNNaNNaNNaN325.0NaN369.0NaNNaNNaN1.50000090
12022-01-01C11.0256808201230A1120.060.0NaNNaNNaN90.08.4510650.887570390.0NaNNaNNaNNaNNaN325.0NaN369.0NaN5NaN6.500000390
22022-01-01A1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1.000.000000NaN60.0NaNNaNNaNNaN49.0NaN346.0NaNNaNNaN1.00000060
32022-01-01A11.015-18005201231A1120.060.0NaNNaNNaN300.0140.002142.857143420.0NaNNaNNaNNaNNaN498.0NaN368.0NaN15NaN7.000000420
42022-01-01A11.015-18005201231A1120.060.0NaNNaNNaN147.5140.001053.571429200.0NaNNaNNaNNaNNaN248.0NaN368.0NaN8NaN3.333333200
52022-01-01A1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1.000.000000NaN40.0NaNNaNNaNNaN248.0NaN368.0NaNNaNNaN0.66666740
62022-01-01C1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1.000.000000NaN240.0NaNNaNNaNNaN248.0NaN368.0NaNNaNNaN4.000000240
72022-01-01C21.05-74454201230A1120.060.0NaNNaNNaN15.4138.00111.59420360.0NaNNaNNaNNaNNaN325.0NaN369.0NaN1NaN1.00000060
82022-01-01C21.05-34666201231A1120.060.0NaNNaNNaN80.057.201398.601399420.0NaNNaNNaNNaNNaN325.0NaN369.0NaN4NaN7.000000420
92022-01-01A21.05-34666201231A1120.060.0NaNNaNNaN70.057.201223.776224270.0NaNNaNNaNNaNNaN49.0NaN368.0NaN4NaN4.500000270

Last rows

日期班別爐號原料分類原料品編批號燒結溫度速度急冷速率快速脫臘重量(kg)單重(g)數量實際燒結時數待料時數持溫時數更換溫度時數爐體維修時間表單編號確認者填表人收料者盒數箱數燒結狀態工時(H)工時加總
190162022-12-31C81.08-26556211224A1120.060.0NaNNaNNaN387.8128.253023.781676480.0NaNNaNNaNNaN535.049.0NaN318.0NaN18NaN8.000000480
190172022-12-31A81.08-26556211224A1120.060.0NaNNaNNaN409.3128.253191.423002385.0NaNNaNNaNNaN535.0286.0NaN324.0NaN19NaN6.416667385
190182022-12-31A81.020-26534NaN1120.060.0NaNNaNNaN92.1209.00440.66985695.0NaNNaNNaNNaN535.0286.0NaN324.0NaN15NaN1.58333395
190192022-12-31A81.015-43394211227A1120.060.0NaNNaNNaN200.0308.00649.350649240.0NaNNaNNaNNaN535.0248.0NaN324.0NaN10NaN4.000000240
190202022-12-31C81.015-43394211227A1120.060.0NaNNaNNaN200.0308.00649.350649240.0NaNNaNNaNNaN535.0248.0NaN369.0NaN10NaN4.000000240
190212022-12-31C9NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1.000.000000NaN480.0NaNNaNNaN96.049.0NaN361.0NaNNaNNaN8.000000480
190222022-12-31A9NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1.000.000000NaN480.0NaNNaNNaN96.0286.0NaN346.0NaNNaNNaN8.000000480
190232022-12-31A9NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1.000.000000NaN210.0NaNNaNNaN96.0248.0NaN346.0NaNNaNNaN3.500000210
190242022-12-31A91.0173609211229C800.050.0NaNNaNNaNNaN28.500.00000030.0NaNNaNNaNNaN96.0248.0NaN393.0NaNNaNNaN0.50000030
190252022-12-31C91.0173609211229C800.050.0NaNNaNNaN120.028.504210.526316240.0NaNNaNNaNNaN96.0248.0NaN217.0NaN6NaN4.000000240